excel中设置分列分隔符(空格分隔符)成公式,以便下次打开还有用_百度知...答:假设要分列的数据在A列 B1输入公式 =MID(" "&$A1&" ",FIND("#",SUBSTITUTE(" "&$A1&" "," ","#",COLUMN(A:A)))+1,FIND("#",SUBSTITUTE(" "&$A1&" "," ","#",COLUMN(B:B)))-FIND("#",SUBSTITUTE(" "&$A1&" "," ","#",COLUMN(A:A)))此公式向右和向下复制,可...
excel中如何分离公司名,电话,和邮箱到不同列答:B2公式=LEFT(A2,FIND("+",A2)-1)C2公式=TRIM(SUBSTITUTE(LEFT(A2,COUNT(FIND(" ",A2,ROW($1:$99)))-1),B2,)),公式输完后按CTRL+SHIFT+ENTER结束 D2公式=MID(A2,COUNT(FIND(" ",A2,ROW($1:$99)))+1,99),公式输完后按CTRL+SHIFT+ENTER结束 公式下拉。